Limitations and considerations
The following limitations apply to the Amazon S3 target endpoint:
- The following DDLs are supported only: Truncate table, Drop table, Create table, Add Column, Rename Column, Drop Column, and Convert Data Type.
- Full LOB Mode is not supported
- UPDATE and DELETE statements are not supported in Apply Changes replication mode
- Batch optimized apply mode is not supported
- Target lookup is not supported
- The <target folder> parameter cannot include special characters
-
Limitations when using Parquet file format:
-
When the DDL Handling Policy for source tables is set to Ignore ALTER, the RENAME COLUMN DDL (on a Primary Key column) is not supported.
-
LOB columns larger than 1 MB are not supported.
-
- Database names, schema names, or table names containing slash (/) or backslash (\) characters are not supported.
- The following Control Tables are not supported as they require UPDATE/DELETE operations, which are not supported:
Replication Status (requires UPDATE).
Name on target:
attrep_status
Suspended Tables (requires DELETE).
Name on target:
attrep_suspended_tables
For more information on Control Tables, see Control tables.